package com.caocaog.market.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.hibernate.annotations.Parameter;

import java.math.BigDecimal;

/**
 * @author liguang
 * @version 1.0.0
 * @Project jeecg-boot
 * @Package com.caocaog.market.mapper
 * @ClassName CcptMemberMapper.java
 * @createTime 2022年01月15日 14:27:00
 * @Description 从曹操跑腿数据库取数据
 */
@DS("sql-server-datasource")
public interface CcptMemberMapper {
    /**
     * 获取门店与曹操跑腿绑定的账号（曹操跑腿账号）的余额
     *          也就是曹操跑腿中的发单账号的余额
     */
    @Select("select balance from cc_member where sid=#{sid}")
    BigDecimal findCcptMemberBalanceBySid(@Param("sid") int sid);
}
